User Profile
Lisa_Lashbrook
Copper Contributor
Joined Jun 29, 2022
User Widgets
Recent Discussions
Re: Vlookup not working in large file
When I have this issue, it's usually some data on my lookup table is saved as numer and some as text. The way I eliminate that as an issue, I select the column(s) in my lookup table, go to Data, select text to Columns, confirm "deliminted" is selected, and click finish. That should convert any text to numbers.5KViews0likes0CommentsRe: analysis of an entry
MARKVEASEY What I use is the "IFS" function. create a table with your labels and values, then use =IFS to identify what label you typed and find the corresponding value. Example, I type a label in H3, in I3 I have this IFS formula to go find that label on my table and give me the corresponding value: =IFS(H3=$AF$1,$AE$1,H3=$AD$1,$AC$1,H3=$AB$1,$AA$1,H3=$Z$1,$Y$1,H3=$X$1,$W$1,H3=$V$1,$U$1,H3=$AH$1,$AG$1)1.7KViews0likes1Comment
Recent Blog Articles
No content to show