#### kevinboo

##### Board Regular

- Joined
- Nov 8, 2004

- Messages
- 146

I wonder can anyone help?

I am trying/wanting to use VLOOKUP to consolidate the information from 3 w/shts in the same w/book onto one. They all have one common Pt No in the left hand column which may or may not appear on this Master Sht.

I know how to use VLOOKUP to get info from 1 column, but when I try to drag the formula to the next column the cell ref to look up changes and the column number to look up from remains the same, I want the cell ref (or should I say the column letter) to remain the same and the row number to look at to increase by one.

Anyone ????? Please

Also when I try to auto fill my formula lose the sht to look up from ref?

Is there anyway I can :

A. Either fix the problems I have when dragging the formula

or

B. (Ideally) Enter 1 Formula in a cell which will look up and return the

values from say 14 or so Columns from the sheet I am asking the

VLOOKUP formula to get the info from