View Single Post
  #1   Report Post  
Annieeee Annieeee is offline
Junior Member
 
Posts: 2
Exclamation Look Up Multiple Values And Returning One Value

I've seen multiple posts on this topic but I couldn't understand any of them (either I am just too new to this or it wasn't what I am looking for).

Someone help!

Example of my excel:
SHEET 1
..........A..........B..........C..........D
1.......STATE....HOT.......COLD....WARM (<<THIS IS THE HEADER)
2.........CA
3.........FL
4.........TX

SHEET 2
..........A............B................C......... .
1.......STATE..CLIMATE....TOTAL CITIES (<<THIS IS THE HEADER)
2.........CA.......COLD.............5
3.........FL........HOT..............6
4.........TX........HOT.............15
5.........CA.......WARM............2
6.........CA.......HOT...............7
7.........FL.......COLD..............3
8.........TX.......WARM.............8

Basically, I want to look up the STATE and the CLIMATE and return the values onto Sheet 1. Is this possible? Feedback is certainly appreciated