Fetch data

Solved/Closed
khroliya - Aug 9, 2015 at 01:44 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Aug 10, 2015 at 08:15 AM
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

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250
Aug 9, 2015 at 05:37 AM
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.
0
hi
u can use leader id in result sheet
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250
Aug 10, 2015 at 08:15 AM
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.
0