J

#### Jake

I have a table of 76 items (A277). I want to key the item code into cell

F2 (of the same worksheet) and have Excel populate two pieces of data to the

right of F2 (this would be G2 and H2), that corresponds to the item code

typed in cell F2.

The original data is contained in A277 so I have no problem doing this

when I use Vlookup but the formula only returns to data in the column I

specify, which is one column. I don't know how to write the formula to say I

want two pieces of data that correspond to "the value I enter" in the Vlookup.

I am sure what I've typed above is probably as clear as muddy water...

Thanks for any help you can offer, it is greatly appreciated.