Hi
I know this is possible but can't work it out!
When doing a V-lookup I have always entered 2 in Col_Index_num to return one column of data at a time. I'm pretty sure if the table array had 4 columnns of data to return I could do this with one V-lookup by altering the information I put in Col_Index_num.
Can anyone help please?
Thanks
Abby
I know this is possible but can't work it out!
When doing a V-lookup I have always entered 2 in Col_Index_num to return one column of data at a time. I'm pretty sure if the table array had 4 columnns of data to return I could do this with one V-lookup by altering the information I put in Col_Index_num.
Can anyone help please?
Thanks
Abby