Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using two Vlookup in one Cell
I want to Display the Result in Display Value from Table Name Cell any
value / Word from two different tables Enter Value :- B1 is Data entry Cell Display Value from Table :- B2 is Result Cell Table 1 C4 D4 E4 F4 5 1801 A1 A2 A3 A4 6 1802 A2 A2 A3 A4 7 1803 A3 A2 A3 A4 8 1804 A4 A2 A3 A4 9 1805 A5 A2 A3 A4 10 1806 A6 A2 A3 A4 Table 2 C14 D14 E14 F14 G14 14 1807 A1 A2 A3 A4 15 1808 A1 A2 A3 A4 16 1809 A1 A2 A3 A4 17 1810 A1 A2 A3 A4 18 1811 A1 A2 A3 A4 19 1812 A1 A2 A3 A4 If the Entered value in B1 Cell is equals to Table 1 Column D4 to G10 than I want to display any value from D5 to G5 Column Or If the Entered value in B1 Cell is equals to Table 2 Column C14 to G19 than I want to display any value from D14 to G14 Column SO PLEASE GIVE ME CORRECT VLLOKUP FORMULA TO EXTACT VALUE FROM TWO TABLES |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using two Vlookup in one Cell
Hi,
could you give me an example , which number you want to enter and what result are you looking for "Arun" wrote: I want to Display the Result in Display Value from Table Name Cell any value / Word from two different tables Enter Value :- B1 is Data entry Cell Display Value from Table :- B2 is Result Cell Table 1 C4 D4 E4 F4 5 1801 A1 A2 A3 A4 6 1802 A2 A2 A3 A4 7 1803 A3 A2 A3 A4 8 1804 A4 A2 A3 A4 9 1805 A5 A2 A3 A4 10 1806 A6 A2 A3 A4 Table 2 C14 D14 E14 F14 G14 14 1807 A1 A2 A3 A4 15 1808 A1 A2 A3 A4 16 1809 A1 A2 A3 A4 17 1810 A1 A2 A3 A4 18 1811 A1 A2 A3 A4 19 1812 A1 A2 A3 A4 If the Entered value in B1 Cell is equals to Table 1 Column D4 to G10 than I want to display any value from D5 to G5 Column Or If the Entered value in B1 Cell is equals to Table 2 Column C14 to G19 than I want to display any value from D14 to G14 Column SO PLEASE GIVE ME CORRECT VLLOKUP FORMULA TO EXTACT VALUE FROM TWO TABLES |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Vlookup in each cell? | Excel Discussion (Misc queries) | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
How do I. VLOOKUP & BRING BACK THE CELL BELOW THE CELL WHICH IS FO | Excel Worksheet Functions | |||
Vlookup for more than one cell | Excel Discussion (Misc queries) | |||
vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions |