vlookup

Copper Contributor

I've never used vlookup. I have made a pivot table out of my information and I need to pull in information from another sheet. I can not seem to format this correctly. Can you please help?

2 Replies

@staciehamilton2370 

 

You need to format the search range like this:

 

'Sheet Name'!A1:B20

Thank you