MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need help with display formula


Posted by paul on November 01, 2000 11:28 AM

I am working with a worksheet that has multiple rows of data that correspond to a value entered in F3. F3 will correspond to a year value in column B. based on that correlation will be an end number value (in column G) in the row of the correlating number of column B. Is there a way I can get the end value to show up in a designated cell based on F3 and the correlating end value?

EG:
F3=3
B2=3, end value G3 = $30,000. How do I get Cell AA1 to display $30,000 based on F3?


Posted by Tim Francis-Wright on November 03, 2000 1:58 PM

There are probably a number of ways to do what
you want, but I don't quite understand the
relationships between F3, B2, and G3.
Does F3 being 3 mean _G2_ (not G3) is $30,000 because B2 is equal to F3?

If so, you could use in AA1:-
=VLOOKUP(F3,$B:$G,6,FALSE)
(this returns #N/A! if F3 doesn't have a
corresponding entry in column B.

Please post again if this doesn't do what you want.