Using LookUp Data table Searching for data from 1st excel to fill 2nd excel column values

Help Activities
41

Book2.xlsx (2.6 MB) Test Master file.xlsx (62.1 KB)

2 Likes
42

Thank you so much @ImPratham45 we forgot to add $ symbol

43

Your Most Welcome :blush:

1 Like
44

one more small doubt . Shall we get two column values at a time from this formula or only we can get one column value at a time :thinking: :thinking:

45

At a tym only one for a cell for different cell you can use different one

1 Like
46

Thanks a lot @ImPratham45 Have a great day :slight_smile:

47

You Toooo

48

Is it possible to retrieve C column value by keeping at the end $D:$C,2,0

I am not getting C value bro if I make changes from the above formula to retrieve C cell values

49

No u cant u need to give select as C:D

50

On basis of C??

51

No on basis of D @ImPratham45 to get the C cell values based on D

52

Will I able to get C value if I give like this?

53

The value which is primary key it must be at beginning

54

oh ok @ImPratham45 :sweat_smile:

55

While filling data from master excel file, empty rows are filling with some random unknown numbers like below mentioned screenshot.

image
image1612×680 56.1 KB

Initially, it was empty rows are filling with #NA when I put my filter and store data into data table and write it into another excel…the empty rows are filing with random numbers. May I know how to overcome this @ImPratham45

56

This are nothing bt #N/A

1 Like
57

[quote=“ImPratham45, post:12, topic:263121”]
=VLOOKUP(A2,‘Sheet2’!A:C,2,0)
[/quote]. . .

58

So no need to delete these row values ?

59

delete in the sense

60

Like I am able to see the value as number . Client may request me to delete such unknown values in the column

image
image1488×688 70.3 KB