2 different sheet data combine with 1 and genrate data from two other sheet???????????/

**Nikesh_2515** · 05-09-2013, 04:40 AM

Please help in making new database as per my requirement ... i herewith attaching file.

**Fotis1991** · 05-09-2013, 04:48 AM

=lookup(b1,{"a","b","c","d","e"},{10,15,12,15,90,140})

**Nikesh_2515** · 05-09-2013, 05:21 AM

Its ok but in sheet 3 b4 cell ( data extract from sheet 1) how to get data from sheet 1 (customer name)

**Fotis1991** · 05-09-2013, 06:57 AM

Originally Posted by Nikesh_2515

Its ok but in sheet 3 b4 cell ( data extract from sheet 1) how to get data from sheet 1 (customer name)

Which are the criteria for which customer you need to extract....in sheet 3?

**Kevin UK** · 05-09-2013, 06:09 AM

Hi Nikesh_2515

Use your table for the VLOOKUP.
=VLOOKUP(B2,$D$14:$E$18,2,0)

Re: 2 different sheet data combine with 1 and genrate data from two other sheet???????????