would this be an if statement?

G

Guest

I want to automatically populate cell H6 using the chart I have in my
spreadsheet.
if cell G8 = B17 then cell H6 = D17. If G8 = B16 then cell H6 = D16, and so
on.
I know this isn't a true if statement as there is not false. How would I do
this?
Thank you, Anita
 
P

Pete_UK

You don't specify how far your "... and so on ..." should go back to -
assume it is D9. Enter this formula in H6:

=VLOOKUP(G8,B9:D17,3,0)

Change the range B9:D17 to suit your "chart".

Hope this helps.

Pete
 
G

Guest

Thank you Pete, It worked great!

Pete_UK said:
You don't specify how far your "... and so on ..." should go back to -
assume it is D9. Enter this formula in H6:

=VLOOKUP(G8,B9:D17,3,0)

Change the range B9:D17 to suit your "chart".

Hope this helps.

Pete
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date and If problem 6
An easier way? 9
What is wrong with this IF statement? need help. 4
Can a value from a different cell be the false answer in =If quest 6
How do I skip over null cells? 4
subtracting dates in an IF statement 2
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Variations on referencing a cell in another workbook - continued 4

Top