vlookup if

I need a formula that in column F will search and match a table where Column I's value is within Column A and make F egual to the equivalent value in J. I've tried search, match and Vlookup to no luck. Eg, I2 is within A2 so B2 should equal to J2 I3 is within A5 so B5 should equal to J3

Hello, I have 2 columns of data: State City Texas Dallas Texas (not set) Colorado Boulder Utah Salt Lake City I am trying to use a function in a new column to replace city records which equal "(not set)" and reference the respective cell's state to return the correct value. For the...

So I moved the data that I want to use into 1 sheet and I want to compare data on Column 1 with Column B. I want to find out if the data on Column 1 also exist in Column 2. I am using "1" for exist, and "0" for not existing. The problem is, first I tried using my office notebook, but all the...

Dear all, Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems I currently have three files, file (1): File 2: And file 3: Currently, file 3 has the...

Hello, I need some help, I have a worksheet and in one cell I check if it equals to 0 it should do vlookup to other sheet and get from there the information. But I want to add to it that if the vlookup is also equals to 0 so it should do antoher vlookup to another worksheet and get the...

Good Morning accomplished VBA peers. I'm running into a problem. I need to add-in an additional IF parameter and it's complicated. It touches on parts of VBA that I am not comfortable with and frankly, I don't know how to begin. This macro was essentially written by this board anyhow...

The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one... This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the...

Hi Hopefully somebody can help me as my eyes are beginning to burn I have been looking at this so long! Basically I am exporting data from another programme in to Excel and need to perform a less than ordinary (for me) VLOOKUP to another workbook. The aim is to look up the value of column H...