vLOOKUP -in column other than left most

[allenglishboy]

I have two tables in 2 sheets of a workbook.

The first sheet has item id numbers but the sencond sheet has blank entries in the Iten Id column (column D).
Both tables have the exact same columns but the Item ids in sheet 2 are blank.

Column E contains Item names . I want to populate the item IDs in sheet2 using item names as my lookupvalues. Only probelm is the item names arent in the leftmost column

How do i do this?
Thanks

[jeffreybrown]

Maybe...

=INDEX(Sheet1!$D$2:$D$100,MATCH(E2,Sheet1!$E$2:$E$100,0))

[allenglishboy]

thanks, SHouldnt there be reference to the second sheet somewhere???

[jeffreybrown]

E2 is the reference in sheet2.

=INDEX(Sheet1!$D$2:$D$100, >> This is where the value will be returned from

MATCH(E2,Sheet1!$E$2:$E$100,0)) >> Column E contains Item names and that is matched on Sheet1 column E.

Did you try the formula? Did it work/fail...what?