Look-Up Help/Question

[ElvisHess]

Does anyone know a way to do the following:

I want to enter a formula in G20 that will find the value in A20 then lookup (Always Up) until it finds a value in column A that matches A20, I then want it to go 7 columns to the right from the point where it finds the matching value, And give me the value in that field.

Is it even possible.

 

[jmthompson]

Try this:

=VLOOKUP(A20,A1:H19,8,FALSE)

 

[ElvisHess]

I forgot to add that the lookup would be on a different worksheet tab. I am testing what you sent now.

Thank you for your quick response!!!!!

 

[jmthompson]

Which information is where?

G20 is on what sheet?
A20 is on what sheet?
A1:A19 is on what sheet?