How to include an IF statement in an INDEX MATCH function

[reasem]

Hello, I have a formula i'm working on. I'm trying to pull a number from a different sheet using a ssn as my lookup value. It's working quite well but I want to include an IF statement to analyze the line that I'm pulling the number from. Note: The second sheet that i'm pulling from is an export sheet of documents stating ssn, the number I want, and page number. I want to include IF statement(s) that if the page length is above 1 to put the number im pulling into column A but if the page length is 1 to pull the number in column B.

Any ideas?

Thank you.

Here's my formula so far:
=IFERROR(INDEX('Data Dump'!H:W,MATCH(CONCATENATE("XXXXX",RIGHT('Documents on File'!R3195,4)),'Data Dump'!G:G,0),16),"")

 

[DanteAmor]

that if the page length

What do you mean by "page length"?

 

[reasem]

What do you mean by "page length"?

Just the length of that specific document in pages

 

[DanteAmor]

Do you want to know the number of pages of an excel sheet?
I don't know a formula that can get that data.
It must be with VBA.

 

[reasem]

Do you want to know the number of pages of an excel sheet?
I don't know a formula that can get that data.
It must be with VBA.

The pages i'm referring to is data in the spreadsheet. It looks something like this:

SSN	Number	Pages
XXXXX4518	477846	1
XXXXX3259	487156	34

I have the function to pull the number from another table using the ssn. I now have 2 columns on the other sheet for either documents with above 1 pages and documents with 1 page. The same function will probably need to be in both columns but Im struggling on where to put the IF statement if needed

 

[DanteAmor]

I am not understanding well what you need.
With the example you set you can put the expected results.

You can paste cell ranges using the following:
Welcome to Version 4 of the New MrExcel Message Board!