Get instant live Excel expert help with LOOKUP Function

I want to combine vlookup different sheet and sum function. i want to search different expense head in column I and through vlookup and sum them in one formullah

I have two sets of annual data with the same layout in two worksheets. The first column (A) is the position and starts at 1 (this is sorted based on Column C). Column B is the company name, Column C is how much we've earned from them in the year. I want to add the up/down/equal arrows into Column A based on their position from one year to the next. In my head the formula would need to be (in pure text terms): Where B1 in Sheet 1 equals B__ [say 10] (some sort of lookup needs to take place) in Sheet 2, If A1<A10 then arrow is down, if A1=A10 then arrow is equal, if A1>A10 then arrow is up How do I write this as a conditional format?

I need to auto-determine lookup range based on one cell.

hi im trying to use lookup to match data from one tab to another but its giving me error #na can you please help me

hey I just want how to v lookup so regarding this i just help kindly assets me

I would like to perform Fuzzy lookup for comparing to names and kutool to select record with certain values. can you please help me with this? Thanks

How do I use index match when my lookup value is a formula?

i want to use the lookup function but i do not know how

I have a vlookup formula but it seems that excel is not recognizing the lookup value in the cell. I already checked that the formula is correct, and the formatting is not text. Any other reasons why it isn't recognizing the cell value?

What is the formula that you entered into cell D7 to lookup the selected employee's title?