vlookup(lookup_value,table_array,col_index,[range_lookup])

you can use =VLOOKUP(A1,$G$1:$i$7,3,0) - will return the value on I column
(3rd column)

=VLOOKUP(A1,$G$1:$i$7,2,0) - will return the value on H column (2nd column)

is it answer your question?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"GKW in GA" escreveu:

If the table array is more than 2 columns, is it possible to paste more than
one column into the target cols. Lets say the table-array instead of G1:H7,
it's G1:I7. Is there a way to paste Hx:Ix into Cx:Dx if Ax is found in G1:G7
(where x is the row number)

"Marcelo" wrote:

=VLOOKUP(A1,$G$1:$H$7,2,0)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"GKW in GA" escreveu:

When I enter a VLOOKUP formula in a cell and then copy and paste it all the
way down the remainder of the column, it not only changes the cell of the
lookup value, it also changes the row/column of the table - array

Example:
If I enter =VLOOKUP(A1,G1:H7,2,0) in cell C1 and then copy and paste it to
cell C2, it changes C2 to =VLOOKUP(A2,G2:H8,2,0).

What I really want is for C2 to contain the result of looking up A2 in G1:H7
just like it does for C1. I dont want it to look in G2:H8.

Similarly, pasting the formula into C3 causes it to look in G3:H9 i/o G1:H7.