kevinboo
Board Regular
- Joined
- Nov 8, 2004
- Messages
- 146
Hi All
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
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