Fetch data [Solved/Closed]

Report
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
fist sheet

Leader id Brand Status product
S001 Maruti complete Maruti 800
s002 Toyota complete xyz
s003 Maruti complete swift desire
s004 Nishan complete Micra
s005 Maruti cancle Alto

second sheet
Dealer id Dealer name Brand
dd1 aa Maruti
dd2 dd Toyoto
dd3 gh Walkswogn
dd4 kk Nishan
dd5 hh Honda
dd6 hjt suzuki



need of Result

Delear id Dealer name Brand Status Product

please help me to find the data from upper two sheet

2 replies

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
Hello Khroliya,

Shouldn't the headings in both the first and second sheets be the same?
Should they not be the same as the headings in the "Result" sheet?:-

Dealer ID    Dealer Name    Brand    Status    Product


It would be best if you uploaded a sample of your work book showing your inputs and expected results so that we can understand exactly what it is that you are trying to do.
You can upload a sample of your work book using a free file sharing site such as DropBox, ge.tt or Speedyshare. Someone should then be able to help you.

Cheerio,
vcoolio.
hi
u can use leader id in result sheet
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
Hello Khroliya,

We still need answers to the two questions.

Furthermore, is "leader id" just a type error which should read "Dealer ID"?.

Please also upload a sample of your work book as previously requested.

Thank you and regards.
vcoolio.