Burnsieboy
New Member
- Joined
- Aug 19, 2016
- Messages
- 16
Morning all,
I am trying to make my sheet more robust by changing my usual vlookup
=IF($B9>0,VLOOKUP($B9,Full_list_Data,2,FALSE),"")
to something more like
=IF($B9>0,VLOOKUP($B9,Table1[Project Name],Table1,0),0)
the "Full_List_Data" or "Table1" data table is on another sheet and the table is B:CZ
I want to be able to rearrange the columns in the data table without affecting the existing column lookup numbers in the formulas on the other worksheets - there are lots
I am trying to make my sheet more robust by changing my usual vlookup
=IF($B9>0,VLOOKUP($B9,Full_list_Data,2,FALSE),"")
to something more like
=IF($B9>0,VLOOKUP($B9,Table1[Project Name],Table1,0),0)
the "Full_List_Data" or "Table1" data table is on another sheet and the table is B:CZ
I want to be able to rearrange the columns in the data table without affecting the existing column lookup numbers in the formulas on the other worksheets - there are lots